<?php

class Country {

    private static $_instance;

    public static function getInstance() {
        if (!(self::$_instance instanceof self)) {
            self::$_instance = new self();
        }
        return self::$_instance;
    }

    // Do not allow an explicit call of the constructor: $v = new Singleton();
    final private function __construct() {
        
    }

    // Do not allow the clone operation: $x = clone $v;
    final private function __clone() {
        
    }

    function __destruct() {
        
    }

    public static function getActiveCountries() {

        $sql = 'SELECT pai_CodElite  AS ID, pai_nombreUSD AS NAME
		FROM officeschema.hd_paises
		JOIN officeschema.hd_detalletarifas ON officeschema.hd_detalletarifas.dtr_Pais=officeschema.hd_paises.pai_CodElite
		WHERE officeschema.hd_paises.pai_ActivoGiros=1
		AND dtr_status=5
		GROUP BY pai_codeiso
		ORDER BY NAME ASC;';
        return $sql;
        //$db = Db::getInstance();
        //return $db->getall($sql);
    }

    public static function getCities() {
        
    }

    public static function getBanks() {
        
    }

    public static function getRegion() {
        
    }

}